Welcome
Guest
, you are in:
<root>
•
Login
devio dbscript ScrewTurn Wiki
Navigation
¶
Main Page
Random Page
Create a new Page
All Pages
Categories
Navigation Paths
Administration
File Management
Create Account
Search the wiki
»
Discuss (0)
View Page Code
History
public assets (table)
Print
RSS
Modified on 2011/08/27 11:43
by
wikibot
Categorized as
Uncategorized
public node (table)
public node (table)
»
public assets (table)
[X]
»
public assets (table)
wikibot
¶
Table
public.assets
Columns
¶
Column
Data Type
Nullable
Default
Description
id
integer
not null
nodeid
integer
null
category
varchar(64)
not null
manufacturer
varchar(64)
null
vendor
varchar(64)
null
modelnumber
varchar(64)
null
serialnumber
varchar(64)
null
description
varchar(128)
null
circuitid
varchar(64)
null
assetnumber
varchar(64)
null
operatingsystem
varchar(64)
null
rack
varchar(64)
null
slot
varchar(64)
null
port
varchar(64)
null
region
varchar(64)
null
division
varchar(64)
null
department
varchar(64)
null
address1
varchar(256)
null
address2
varchar(256)
null
city
varchar(64)
null
state
varchar(64)
null
zip
varchar(64)
null
building
varchar(64)
null
floor
varchar(64)
null
room
varchar(64)
null
vendorphone
varchar(64)
null
vendorfax
varchar(64)
null
vendorassetnumber
varchar(64)
null
userlastmodified
char(20)
not null
lastmodifieddate
timestamp with time zone
not null
dateinstalled
varchar(64)
null
lease
varchar(64)
null
leaseexpires
varchar(64)
null
supportphone
varchar(64)
null
maintcontract
varchar(64)
null
maintcontractexpires
varchar(64)
null
displaycategory
varchar(64)
null
notifycategory
varchar(64)
null
pollercategory
varchar(64)
null
thresholdcategory
varchar(64)
null
comment
text
null
managedobjectinstance
varchar(512)
null
managedobjecttype
varchar(512)
null
Primary Key
¶
Primary Key
Columns
pk_assetid
id
Indexes
¶
Index
Type
Columns
assets_an_idx
assetnumber
assets_nodeid_idx
nodeid
Foreign Keys
¶
Relation
Column
Referenced Column
public.node
nodeid
nodeid
ScrewTurn Wiki
version 3.0.1.400. Some of the icons created by
FamFamFam
.